Country and sector profile: shows number of projects per year for sector and country

Two parameters are required, sector and country

ERROR: parameter sector has an invalid value
ERROR: parameter country has an invalid value
sectoridtest link JSONtest link JSONP
ACTION RELATING TO DEBTS100?sector=S100?sector=S100&jsonp
AGRICULTURE, FORESTRY, FISHINGS101?sector=S101?sector=S101&jsonp
BANKING AND FINANCIAL SERVICESS102?sector=S102?sector=S102&jsonp
BUSINESS AND OTHER SERVICESS103?sector=S103?sector=S103&jsonp
COMMUNICATIONSS104?sector=S104?sector=S104&jsonp
DEVELOPMENTAL FOOD AID/FOOD SECURITY ASSISTANCES105?sector=S105?sector=S105&jsonp
DISASTER PREVENTION AND PREPAREDNESSS106?sector=S106?sector=S106&jsonp
EDUCATIONS107?sector=S107?sector=S107&jsonp
EMERGENCY RESPONSES108?sector=S108?sector=S108&jsonp
ENERGYS109?sector=S109?sector=S109&jsonp
GENERAL BUDGET SUPPORTS110?sector=S110?sector=S110&jsonp
GENERAL ENVIRONMENTAL PROTECTIONS111?sector=S111?sector=S111&jsonp
GOVERNMENT AND CIVIL SOCIETYS112?sector=S112?sector=S112&jsonp
HEALTHS113?sector=S113?sector=S113&jsonp
INDUSTRY, MINING, CONSTRUCTIONS114?sector=S114?sector=S114&jsonp
OTHER COMMODITY ASSISTANCES115?sector=S115?sector=S115&jsonp
OTHER MULTISECTORS116?sector=S116?sector=S116&jsonp
OTHER SOCIAL INFRASTRUCTURE AND SERVICESS117?sector=S117?sector=S117&jsonp
POPULATION POLICIES/PROGRAMMES AND REPRODUCTIVE HEALTHS118?sector=S118?sector=S118&jsonp
RECONSTRUCTION RELIEF AND REHABILITATIONS119?sector=S119?sector=S119&jsonp
TRADE POLICIES AND REGULATIONSS120?sector=S120?sector=S120&jsonp
TRANSPORT AND STORAGES121?sector=S121?sector=S121&jsonp
UNALLOCATED/UNSPECIFIEDS122?sector=S122?sector=S122&jsonp
WATER SUPPLY AND SANITATIONS123?sector=S123?sector=S123&jsonp

sector :: FORWARD lookup table JSON:

sector :: REVERSE lookup table JSON:

countryidtest link JSONtest link JSONP
AfghanistanC100?country=C100?country=C100&jsonp
Africa, regionalC101?country=C101?country=C101&jsonp
AlbaniaC102?country=C102?country=C102&jsonp
AlgeriaC103?country=C103?country=C103&jsonp
America, regionalC104?country=C104?country=C104&jsonp
AngolaC105?country=C105?country=C105&jsonp
Antigua and BarbudaC106?country=C106?country=C106&jsonp
ArgentinaC107?country=C107?country=C107&jsonp
ArmeniaC108?country=C108?country=C108&jsonp
Asia, regionalC109?country=C109?country=C109&jsonp
AzerbaijanC110?country=C110?country=C110&jsonp
BahamasC111?country=C111?country=C111&jsonp
BangladeshC112?country=C112?country=C112&jsonp
BarbadosC113?country=C113?country=C113&jsonp
BelarusC114?country=C114?country=C114&jsonp
BeninC115?country=C115?country=C115&jsonp
BoliviaC116?country=C116?country=C116&jsonp
Bosnia and HerzegovinaC117?country=C117?country=C117&jsonp
BotswanaC118?country=C118?country=C118&jsonp
BrazilC119?country=C119?country=C119&jsonp
Brunei DarussalamC120?country=C120?country=C120&jsonp
BulgariaC121?country=C121?country=C121&jsonp
BurundiC122?country=C122?country=C122&jsonp
Cabo VerdeC123?country=C123?country=C123&jsonp
CambodiaC124?country=C124?country=C124&jsonp
CameroonC125?country=C125?country=C125&jsonp
Central African RepublicC126?country=C126?country=C126&jsonp
ChadC127?country=C127?country=C127&jsonp
ChileC128?country=C128?country=C128&jsonp
ColombiaC129?country=C129?country=C129&jsonp
ComorosC130?country=C130?country=C130&jsonp
CongoC131?country=C131?country=C131&jsonp
Cook IslandsC132?country=C132?country=C132&jsonp
Costa RicaC133?country=C133?country=C133&jsonp
Cote d'IvoireC134?country=C134?country=C134&jsonp
CubaC135?country=C135?country=C135&jsonp
CuracaoC136?country=C136?country=C136&jsonp
Democratic People's Republic of KoreaC137?country=C137?country=C137&jsonp
Democratic Republic of the CongoC138?country=C138?country=C138&jsonp
DjiboutiC139?country=C139?country=C139&jsonp
DominicaC140?country=C140?country=C140&jsonp
Dominican RepublicC141?country=C141?country=C141&jsonp
EcuadorC142?country=C142?country=C142&jsonp
EgyptC143?country=C143?country=C143&jsonp
El SalvadorC144?country=C144?country=C144&jsonp
Equatorial GuineaC145?country=C145?country=C145&jsonp
EritreaC146?country=C146?country=C146&jsonp
EthiopiaC147?country=C147?country=C147&jsonp
Europe, regionalC148?country=C148?country=C148&jsonp
FijiC149?country=C149?country=C149&jsonp
French PolynesiaC150?country=C150?country=C150&jsonp
GabonC151?country=C151?country=C151&jsonp
GambiaC152?country=C152?country=C152&jsonp
GeorgiaC153?country=C153?country=C153&jsonp
GhanaC154?country=C154?country=C154&jsonp
GrenadaC155?country=C155?country=C155&jsonp
GuamC156?country=C156?country=C156&jsonp
GuineaC157?country=C157?country=C157&jsonp
Guinea-BissauC158?country=C158?country=C158&jsonp
GuyanaC159?country=C159?country=C159&jsonp
HaitiC160?country=C160?country=C160&jsonp
HondurasC161?country=C161?country=C161&jsonp
IndiaC162?country=C162?country=C162&jsonp
IndonesiaC163?country=C163?country=C163&jsonp
IranC164?country=C164?country=C164&jsonp
IraqC165?country=C165?country=C165&jsonp
IsraelC166?country=C166?country=C166&jsonp
JamaicaC167?country=C167?country=C167&jsonp
JordanC168?country=C168?country=C168&jsonp
KazakhstanC169?country=C169?country=C169&jsonp
KenyaC170?country=C170?country=C170&jsonp
KiribatiC171?country=C171?country=C171&jsonp
Kyrgyz RepublicC172?country=C172?country=C172&jsonp
Lao People's Democratic RepublicC173?country=C173?country=C173&jsonp
LebanonC174?country=C174?country=C174&jsonp
LesothoC175?country=C175?country=C175&jsonp
LiberiaC176?country=C176?country=C176&jsonp
LibyaC177?country=C177?country=C177&jsonp
MadagascarC178?country=C178?country=C178&jsonp
MalawiC179?country=C179?country=C179&jsonp
MalaysiaC180?country=C180?country=C180&jsonp
MaldivesC181?country=C181?country=C181&jsonp
MaliC182?country=C182?country=C182&jsonp
Marshall IslandsC183?country=C183?country=C183&jsonp
MauritaniaC184?country=C184?country=C184&jsonp
MauritiusC185?country=C185?country=C185&jsonp
MexicoC186?country=C186?country=C186&jsonp
MicronesiaC187?country=C187?country=C187&jsonp
Middle East, regionalC188?country=C188?country=C188&jsonp
MoldovaC189?country=C189?country=C189&jsonp
MongoliaC190?country=C190?country=C190&jsonp
MontenegroC191?country=C191?country=C191&jsonp
MoroccoC192?country=C192?country=C192&jsonp
MozambiqueC193?country=C193?country=C193&jsonp
Multi-RegionC194?country=C194?country=C194&jsonp
MyanmarC195?country=C195?country=C195&jsonp
NamibiaC196?country=C196?country=C196&jsonp
NauruC197?country=C197?country=C197&jsonp
NepalC198?country=C198?country=C198&jsonp
NicaraguaC199?country=C199?country=C199&jsonp
NigerC200?country=C200?country=C200&jsonp
NigeriaC201?country=C201?country=C201&jsonp
NiueC202?country=C202?country=C202&jsonp
North MacedoniaC203?country=C203?country=C203&jsonp
Oceania, regionalC204?country=C204?country=C204&jsonp
OmanC205?country=C205?country=C205&jsonp
PakistanC206?country=C206?country=C206&jsonp
PalauC207?country=C207?country=C207&jsonp
PanamaC208?country=C208?country=C208&jsonp
Papua New GuineaC209?country=C209?country=C209&jsonp
ParaguayC210?country=C210?country=C210&jsonp
PeruC211?country=C211?country=C211&jsonp
PhilippinesC212?country=C212?country=C212&jsonp
RomaniaC213?country=C213?country=C213&jsonp
RussiaC214?country=C214?country=C214&jsonp
RwandaC215?country=C215?country=C215&jsonp
Saint LuciaC216?country=C216?country=C216&jsonp
SamoaC217?country=C217?country=C217&jsonp
Sao Tome and PrincipeC218?country=C218?country=C218&jsonp
SenegalC219?country=C219?country=C219&jsonp
SerbiaC220?country=C220?country=C220&jsonp
SeychellesC221?country=C221?country=C221&jsonp
Sierra LeoneC222?country=C222?country=C222&jsonp
Sint Maarten (Dutch part)C223?country=C223?country=C223&jsonp
SomaliaC224?country=C224?country=C224&jsonp
South AfricaC225?country=C225?country=C225&jsonp
South SudanC226?country=C226?country=C226&jsonp
Sri LankaC227?country=C227?country=C227&jsonp
SudanC228?country=C228?country=C228&jsonp
SurinameC229?country=C229?country=C229&jsonp
Syrian Arab RepublicC230?country=C230?country=C230&jsonp
TajikistanC231?country=C231?country=C231&jsonp
TanzaniaC232?country=C232?country=C232&jsonp
ThailandC233?country=C233?country=C233&jsonp
Timor-LesteC234?country=C234?country=C234&jsonp
TogoC235?country=C235?country=C235&jsonp
TongaC236?country=C236?country=C236&jsonp
Trinidad and TobagoC237?country=C237?country=C237&jsonp
TunisiaC238?country=C238?country=C238&jsonp
TurkeyC239?country=C239?country=C239&jsonp
TurkmenistanC240?country=C240?country=C240&jsonp
UgandaC241?country=C241?country=C241&jsonp
UkraineC242?country=C242?country=C242&jsonp
UruguayC243?country=C243?country=C243&jsonp
UzbekistanC244?country=C244?country=C244&jsonp
VanuatuC245?country=C245?country=C245&jsonp
VenezuelaC246?country=C246?country=C246&jsonp
Viet NamC247?country=C247?country=C247&jsonp
West Bank and Gaza StripC248?country=C248?country=C248&jsonp
YemenC249?country=C249?country=C249&jsonp
ZambiaC250?country=C250?country=C250&jsonp
ZimbabweC251?country=C251?country=C251&jsonp

country :: FORWARD lookup table JSON:

country :: REVERSE lookup table JSON: